﻿CREATE TABLE [dbo].[DefinedViewParameters] (
    [ViewName]      NVARCHAR (50)  NOT NULL,
    [ParameterName] NVARCHAR (50)  NOT NULL,
    [DataType]      NVARCHAR (50)  NULL,
    [Required]      BIT            NULL,
    [RequestText]   NVARCHAR (500) NULL,
    CONSTRAINT [PK_DefinedViewParameters] PRIMARY KEY CLUSTERED ([ViewName] ASC, [ParameterName] ASC),
    CONSTRAINT [FK_DefinedViewParameters_DefinedViews] FOREIGN KEY ([ViewName]) REFERENCES [dbo].[DefinedViews] ([ViewName]) ON UPDATE CASCADE
);



